

USE [bmig_Mensual_Post_cadena]
GO

IF EXISTS (SELECT name FROM   sysobjects WHERE  name = 'WASP_M0011_CREATBL_Seg_SaludFo' AND type = 'P')
    DROP PROCEDURE [dbo].[WASP_M0011_CREATBL_Seg_SaludFo]
GO

CREATE PROCEDURE [dbo].[WASP_M0011_CREATBL_Seg_SaludFo]

AS

BEGIN 
		if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[seg_saludFo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
		drop table [dbo].[seg_saludFo]


		CREATE TABLE [dbo].[seg_saludFo] (
			[fono] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
			[ctnro] [int] NOT NULL 
		) ON [PRIMARY]

END